SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023634 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023634 [ RunTime:0.002735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657113,933688,504925,1016530,984188,310846,989025,588402,763665,330428,515872,174229,380886,257060,523018,927070,836604,154881,421782,21991,237352,403666,898498,804772,501171,694546,488129,922266,706042,379393,662336,1009483,976592,693317,417885,520173,330560,485099,12957,467600,4754,699990,336224,125262,711922,971501,668235,532128,679636,171650,790998,919511,147302,838567,605553,908224,111865,611319,866768,498051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023634 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023634 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003456s ]