SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456951 LIMIT 1 [ RunTime:0.002333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456951 [ RunTime:0.001492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048833,588605,774593,736765,885235,887709,692143,368221,289593,852864,445248,593186,495689,438214,530470,935759,444402,155001,5902,505538,1015749,141672,921177,414835,802354,1025147,535514,501896,738178,389057,313833,79286,189299,340856,109056,412349,783760,993308,54851,430466,520806,501748,121636,944700,528114,775019,793105,273536,749785,919908,1014731,19514,53002,1048313,679569,921707,89975,311232,503888,417740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]