SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540823 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540823 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981593,325256,587188,341848,395898,501042,167500,29757,293082,616584,39432,383699,843901,139167,629359,836167,307765,974771,36567,760360,927717,810416,247725,210374,1007348,36877,665372,344067,168589,628921,970918,450809,181450,361583,483806,479803,41421,480641,57949,78727,8739,449485,240053,721519,171848,111120,230660,63263,355623,234777,26422,601005,940834,341811,969044,358364,76919,625422,812053,719324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001007s ]