SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405154 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405154 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692596,886119,77646,150638,550436,194940,164722,436463,532246,787316,527451,538916,708627,837607,785833,319631,977882,249929,541991,1035483,499597,966315,113763,984125,308162,126192,611580,785601,1000486,349589,109780,916318,166404,704273,309370,908368,222366,814807,542487,261242,421376,324123,421459,348667,587973,115375,999143,901275,822397,903907,839390,985253,983817,700688,811699,637892,426021,86238,83297,516144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405154 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405154 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]