SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001642s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509296 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509296 [ RunTime:0.002976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575166,992312,122368,641630,542171,348412,437817,655990,811242,475974,620705,43061,86673,427810,288201,53726,238654,849611,952677,706232,80584,180937,1023684,966288,923937,904236,437840,892889,557181,238188,403238,935849,35888,36082,860052,36374,753193,370516,560073,1036162,105445,209862,906992,296140,451049,64209,654424,267314,862702,1041392,417652,755159,396019,828251,1728,1027784,243637,146621,785768,235856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509296 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509296 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001825s ]