SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538415 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538415 [ RunTime:0.002640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181557,372153,793133,139615,867958,997169,166080,492046,997395,945354,391142,1001492,507330,637212,43180,1021251,117327,176861,569707,938844,695374,979624,321884,227030,1014884,76101,913353,374095,145732,70851,387378,510034,506069,525356,131697,180341,769189,283620,809946,83072,732087,629997,986097,849671,801425,861069,174217,129608,251776,552920,385021,637588,834887,703541,580393,2144,8579,785116,333315,592788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]