SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501643 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501643 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748743,469961,705759,243186,990008,9619,135892,627783,66665,458927,506708,483002,650644,687495,159713,1023102,668217,442471,418477,673731,991874,917898,567263,385733,532678,448777,999695,578914,208221,859989,852080,526968,556681,947812,2701,814131,604050,1028774,73338,675740,944707,557998,628080,517448,694061,544839,874168,831246,216838,678006,786146,443493,375878,891451,804478,417876,155214,910260,128219,206154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001219s ]