SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982658 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982658 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122911,863798,722930,122800,1026291,816162,300506,117914,139598,20011,219117,139747,665914,704737,967529,846366,221350,1033914,287793,824211,704120,668267,456850,307724,875781,171229,152762,513452,696778,654535,436770,208381,429114,746901,398799,88260,171533,504418,189247,723950,654360,856182,660032,216235,798794,103129,638129,639586,275626,977875,268630,930550,173527,112450,759,397922,586773,620405,275104,495245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001847s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]