SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494028 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494028 [ RunTime:0.002479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615468,516761,573920,777722,221224,773507,988589,766765,505853,520284,576038,723048,811599,338043,906748,888860,295422,875389,866998,641083,580193,915795,301924,972565,226933,427673,27143,385995,550059,675054,827948,620107,860350,263697,528187,1031389,114117,991954,549120,403146,155950,545839,326630,702740,106579,842678,648014,705277,819562,75950,937954,120176,854720,477950,1004720,330447,205659,936081,522776,108681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001900s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]