SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413774 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413774 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495429,890765,528837,917617,636266,441567,609756,588100,353310,489342,110658,244790,519394,680940,13426,900004,912242,507741,332978,717056,266911,902130,698158,416145,592761,12230,628275,209206,1015968,622076,126280,665475,659928,502974,439541,712321,180450,972611,810609,375877,788543,94486,1016060,378218,674869,1041341,379854,591953,537987,420339,189000,637608,894251,155694,392378,988346,360794,914851,190645,930565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413774 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413774 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]