SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043150 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043150 [ RunTime:0.004923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429521,923230,721950,1031574,121537,474538,779795,310773,280641,784393,382013,766430,901023,191826,341752,745553,821599,621413,864601,682486,604155,1012774,452050,1011227,614720,1005038,303138,487800,912578,427770,880563,778768,861667,963947,723611,1028596,145121,606562,495401,297538,247496,63366,47513,251375,612367,366851,840194,793080,283361,309226,94724,900789,426929,729824,930422,514399,756405,502950,856145,510940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001537s ]