SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462718 LIMIT 1 [ RunTime:0.001431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462718 [ RunTime:0.007310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665551,134048,89940,284961,375104,999596,939127,721166,923131,843364,277390,352476,254601,808500,829187,322436,888026,449581,345068,837311,348042,900145,885171,467188,986997,145634,665967,623613,42241,171432,665318,740824,735637,400386,527414,969328,788904,936274,821097,339901,520892,588835,293887,933165,665502,366919,544569,839001,141376,434369,791421,1027016,307362,567015,868918,501594,360425,415949,505313,837221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]