SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420036 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420036 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494042,209990,592732,618335,951831,531591,951103,887779,446471,27483,5779,459416,1047299,493541,829954,660317,277919,437778,65956,688760,707054,170526,588018,76615,1043013,921377,1018905,176790,180429,887241,943961,947407,734177,860581,984898,422925,121747,302834,486243,358365,718276,196588,789112,587865,608871,335223,167555,575499,220801,220128,938606,1019603,519019,327913,424751,509740,962438,86603,97000,1037036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]