SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503237 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503237 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113097,603793,400576,314721,371748,305058,673577,881660,510469,720312,437599,158807,599904,816179,349861,125983,217466,502151,1034427,647417,987376,593197,452882,95766,515313,226543,224290,644200,201078,580125,1029169,106838,338775,633113,97552,347269,381389,314575,366417,621728,466824,693153,723484,509172,546232,718771,428763,553428,212901,451488,313026,376957,329129,779000,1045560,450921,101468,400658,1043581,17539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503237 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503237 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]