SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 132004 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 132004 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736191,669696,398688,612018,69628,774294,502573,429275,557040,970759,188040,1033420,1034757,568026,1031154,503233,658965,600595,7124,773471,114135,569364,802426,800042,673203,922642,488729,47839,335007,164182,998660,18531,915750,404766,540966,491669,972105,605588,394331,690788,565111,556955,692745,136884,463195,845601,523569,1035022,370016,701615,672691,88387,400779,914739,601605,135374,518014,746001,716748,382248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 132004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 132004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]