SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497670 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497670 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805009,809420,291371,598896,118744,565142,416812,446099,32571,960453,995086,633998,1005781,142755,473837,724803,863136,1007546,467559,465549,864487,851607,459026,578262,5765,822035,765146,539474,345651,784823,676117,742808,564005,742736,282331,107446,1047402,620876,25322,370863,134059,312085,186305,459110,200890,969940,129948,108654,1025822,512399,847613,739970,194601,194980,767490,542358,960737,436175,444398,331789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]