SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019011 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019011 [ RunTime:0.005190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916765,149917,777585,117466,550575,21021,990071,845443,574660,35200,815697,845864,127423,696784,601837,161882,841870,778645,823459,518475,180053,1018984,520286,370662,532260,387190,965044,261381,654925,415910,906524,893108,679382,117334,194714,835865,214143,895390,47876,325445,759234,840604,264997,463551,353217,286892,400065,285374,494832,486081,376042,814247,552183,375072,546462,891648,1038645,108742,817643,416364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]