SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525092 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525092 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288137,739720,860657,486935,869876,858428,479132,150940,542118,1011046,504678,864092,972426,404320,784041,111905,141102,181147,744990,1003979,502452,1022354,6651,882871,808315,547620,672096,41911,575920,5521,135286,365296,477454,820930,610196,153341,164182,185700,588609,78950,442925,37505,964134,671585,766226,10502,914639,810005,863599,853412,296709,852454,434057,334182,62839,345593,670243,302514,534776,995630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002797s ]