SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549893 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549893 [ RunTime:0.002387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942579,1013875,825893,442533,725910,429405,478627,591317,30957,635387,227428,259535,803441,98233,100580,180291,895884,416541,502803,1038096,225099,569961,1040052,102961,219530,62916,80956,407450,526032,816487,426042,565514,511639,434961,735507,1019057,73669,1031272,564301,598814,571251,446111,35462,391704,272421,1044675,166473,852402,457525,559428,502622,126706,360431,999276,502611,867421,700952,751195,772771,174486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]