SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106198 LIMIT 1 [ RunTime:0.002065s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106198 [ RunTime:0.005645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002180,933436,687765,416923,183878,1036551,310436,282586,1019644,829534,78677,936700,615538,977348,1030859,405148,675128,15620,115415,108484,8455,896548,599217,560558,899121,480684,834126,348581,462368,17497,111767,307836,17171,992524,107311,694179,761142,819471,641730,881204,748516,639123,254352,998780,227737,588835,440521,521985,947427,166024,844117,73843,1027163,476524,101933,90660,622213,773462,411903,787696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003218s ]