SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534451 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534451 [ RunTime:0.002130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509853,192778,339749,916444,1004531,271564,885620,765298,565378,398488,11163,800734,44429,54257,39329,324248,422069,634968,755371,899646,198619,928779,621543,6449,345967,100716,745055,1017054,149787,598333,481151,116893,653231,750023,707093,903489,619561,11168,13287,576999,848557,628688,814607,372193,240212,797019,570045,663734,863554,328926,624866,181051,337917,956098,56042,207979,131279,950945,227205,571502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]