SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010307 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010307 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780737,703773,340181,484099,975937,571545,328817,330417,613130,374380,77772,152703,159607,758514,124339,199861,289232,201050,707012,645893,475230,754912,853474,807958,717494,931518,843065,653742,271200,1008523,766956,643146,1010214,835849,845570,99304,663076,542543,535981,671692,502118,982629,97444,910154,435524,397304,9874,59930,527984,218374,610516,508619,2514,203318,196711,327136,52293,664767,814763,458517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000855s ]