SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 552728 LIMIT 1 [ RunTime:0.001115s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 552728 [ RunTime:0.002911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830026,815566,592754,423050,894331,201782,814177,138116,364397,266718,806788,143906,163068,822945,547177,747718,1033290,842900,951238,764376,186961,460609,425283,27813,824484,94037,277777,311639,1036348,1011396,251347,361359,667163,481741,812748,868551,292931,339288,295234,302045,96864,201652,1019903,489622,356124,909412,305115,968547,159804,722492,404290,708272,539394,17289,574435,764255,488002,223750,893047,57803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 552728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 552728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]