SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531654 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531654 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847827,726979,778327,42122,670999,72418,39569,131320,44574,142669,631348,563979,16736,111088,624608,993050,88992,68737,850655,713372,477678,236545,416658,875138,608851,696440,43353,642270,656941,650720,325124,1026736,605452,998558,532596,573713,520376,522231,563397,63435,194679,99730,713660,71291,33096,907021,506178,953389,863749,230181,786939,635118,686943,247472,832564,305477,836762,426006,968342,828425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]