SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311013 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311013 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470835,3311,922826,80520,213981,16723,67699,731715,919916,598846,447311,929774,700112,582969,19200,193019,436695,504817,538070,765826,691113,147474,180718,1035742,453931,644603,777870,968886,593613,510315,53384,949498,752039,279969,1030796,132971,840566,462595,279523,831443,621696,345939,569031,894127,792651,950762,204627,365453,540274,759372,349549,292048,168900,353576,519157,791044,956163,887872,533487,188184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]