SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296781 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296781 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045759,413544,815174,144462,857924,883793,294771,127940,708044,294889,457417,104878,221359,854986,487986,851953,897385,169908,152148,286915,981117,909635,66601,980420,362792,517537,602836,708430,513549,239799,719307,709438,758015,282796,874339,489974,382765,328190,1033350,552004,739966,1009944,632813,509985,603603,862396,557232,584583,833162,30851,236049,306642,415533,55166,447309,74871,863063,835910,909936,996860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000807s ]