SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507180 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507180 [ RunTime:0.002387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261078,348470,1011027,791768,809556,953406,812139,696743,184581,218616,118219,313754,507595,1042247,629540,755070,642007,909497,825664,432897,130085,135915,266813,977434,929038,328260,453887,937033,503038,120017,253124,249274,545848,465330,883848,841393,481536,650239,984436,428999,591876,115099,543899,233657,1760,442898,632342,210356,501072,136018,991078,640957,301866,72450,574940,605074,899279,376905,53510,533310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]