SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511564 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511564 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860866,580796,237834,123005,718896,565090,693125,889620,464570,197620,243248,878012,483289,339242,288930,965760,337763,489042,727386,995962,450588,758255,310511,103678,595824,45044,114314,202673,41363,547743,583949,686504,601183,906056,356394,98564,398320,431299,38177,38909,928586,40812,821958,465325,376174,1009123,369396,779076,644007,276824,563797,510947,938603,415244,729641,605733,179041,12084,641652,31613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]