SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042791 LIMIT 1 [ RunTime:0.000982s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042791 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200317,907655,6143,381078,11540,103357,788438,704244,182646,748750,547572,494838,164403,75163,1037756,589822,848165,421724,991516,922519,73393,272511,338195,725547,240096,100288,617622,293146,723714,350158,486280,962168,120641,495537,836802,341844,822085,580473,426681,237461,93463,991484,627131,317000,790462,1009967,416253,294235,830125,998828,894016,77139,759002,614002,881613,797607,803857,129811,363209,519000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]