SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281391 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281391 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971468,60826,136170,1019625,65060,156937,772992,806724,516641,443734,900033,629747,208148,49438,846136,703146,1002866,166420,379990,797643,192115,865287,267157,637132,20692,109565,702190,177425,641811,1042789,628133,769988,19052,988754,466070,753985,97377,649855,85370,436615,729633,227782,111611,921514,704302,921282,234709,116172,667719,14688,597896,859051,279508,171027,497503,690678,587875,150586,428497,417129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]