SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028779 LIMIT 1 [ RunTime:0.001412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028779 [ RunTime:0.002467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212512,958504,176146,111170,69533,887715,285052,854002,47308,628355,946777,544030,203601,199589,430104,378554,434922,797694,227142,227155,429185,451645,586375,893685,586197,428678,154730,720525,260055,1016913,749431,402582,261909,111121,482210,865490,137812,475110,565164,744572,427729,311706,501553,548430,484555,468070,935644,179819,356569,1014150,658393,408305,334842,82709,456063,137786,874231,687860,274945,900247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028779 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028779 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]