SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454628 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454628 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236892,900971,238917,145759,641207,305156,103832,1019382,783429,791091,1005273,519450,94062,586992,811127,499450,78643,903600,521602,1047309,931173,598548,496319,1020854,426373,1017286,246644,959356,442705,308821,443473,162149,134945,524011,639514,332765,320848,106240,393842,789267,1047333,610822,146950,338450,606238,897475,51934,974158,589289,623869,4145,464494,301442,441849,886051,210973,258842,177599,529882,172702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]