SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002475s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112652 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112652 [ RunTime:0.005527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002150,265554,715819,799043,341804,980609,353271,299223,8876,902526,346169,329136,429660,456482,105549,311655,753309,113870,937447,3011,389295,777952,180773,254929,1021785,1043019,184608,859132,931800,251202,319176,857230,65086,234162,607659,326892,273827,269640,654372,411342,247650,305966,851217,219043,644557,359718,633305,902483,517339,774829,356080,692917,304719,1042826,882540,521713,230025,175990,601159,143461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112652 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112652 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]