SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045568 LIMIT 1 [ RunTime:0.001003s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045568 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142846,218654,133609,769765,869119,87247,55234,749301,340186,644485,501947,473251,797667,166519,748771,562701,712441,817858,380085,573741,802019,339052,697642,729935,1030757,53883,190965,764836,224542,78603,834142,711639,865644,559897,1024076,93205,208075,609233,604320,38109,283451,497940,554846,690690,1034611,395705,137178,706584,156486,382646,7148,507156,882566,751247,292389,497652,578510,232351,165426,463336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]