SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031596 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031596 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250181,348634,799563,428205,223318,689556,395675,735176,652968,59243,987815,548969,700952,969241,1021184,501750,345264,1019436,180052,901375,753934,1027449,860401,127490,655530,492946,741656,929520,404195,1015668,334254,861041,22302,124699,422816,167078,382772,140464,339563,784860,7381,419480,927990,451054,478838,674004,73204,652390,924214,929181,439599,705459,224469,192025,787312,34266,255448,817396,550573,475197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]