SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538593 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538593 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845085,755988,69841,142760,468856,140485,387161,971418,472778,979214,63822,1013726,701,257433,76609,94078,447393,425865,240917,99348,682602,590530,16538,406246,891643,10885,812410,880884,25842,209939,304895,569463,740532,189157,966987,330278,111920,840984,227776,164192,16608,96946,287201,397818,1046029,483715,483243,900809,184627,857302,834679,629637,485285,939749,488104,338534,628156,383396,87129,38601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]