SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199670 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199670 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723015,737316,305878,500538,93954,459104,817970,130047,76376,1022932,770514,828783,524886,191104,432506,83536,79069,494399,1029837,334742,805986,406058,919423,778646,382263,778113,526501,458113,941631,102364,455872,925529,870096,755703,483582,121615,6603,567410,727813,340477,570746,423123,5688,95447,152559,309297,1040804,192460,72509,959480,396149,893064,775584,4789,794264,696622,23949,565926,397607,56547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]