SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017526 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017526 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859526,115264,722498,675845,1018515,6589,451202,501685,371696,285559,787236,446025,754544,465989,914323,199572,997247,624267,501819,884942,441003,821641,1018869,646498,128580,449324,650282,254280,358104,256606,802660,591251,232361,1014778,270771,365635,713543,839925,1012723,363959,711093,55753,340144,246056,171592,623364,25369,38037,1039571,681237,687167,176761,694926,345885,1033367,909907,768141,277311,837268,644933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]