SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381963 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381963 [ RunTime:0.002641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428998,367264,994236,970895,133912,248640,572739,311174,916278,534792,147090,185093,822890,507657,140790,540533,830254,482639,255605,738538,1024928,681012,657920,451317,412163,67228,50866,756508,925947,28875,410393,308049,680646,497720,613617,25192,450832,391209,578992,982856,407571,699247,109718,185095,798605,766696,756489,325975,318946,77516,695539,21768,491047,981985,39043,497794,722179,980420,809002,421839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]