SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329102 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329102 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862031,277293,192619,111947,498339,712431,465602,1044468,804506,815661,447354,410918,531336,314638,315884,31038,555396,637329,846208,686600,345940,717851,338243,503580,851110,358549,411010,797317,203235,292847,23278,695759,287880,365902,901861,290181,341156,257024,909189,125911,67674,337830,76494,774773,107046,907537,175893,273647,633999,638157,106999,722661,180743,776481,865761,253926,521309,361349,434446,719107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]