SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533202 LIMIT 1 [ RunTime:0.000834s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533202 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461043,801608,53807,235044,920482,671209,553549,353790,1000768,111863,303313,679583,766564,392934,828167,785341,127111,832538,48978,57434,33123,524912,380735,62227,39113,545319,153867,632824,867030,468448,369085,140380,83461,886745,530814,635061,915817,169325,37413,328833,879888,765437,533596,178125,37151,989049,16420,611565,346100,208150,836372,715798,267898,882857,854365,627009,119634,12331,697016,244552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002057s ]