SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334303 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334303 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58636,996458,449128,821619,361983,551595,771381,887477,501587,857999,193162,1019647,188679,225220,521680,375188,221752,334250,782630,989934,570112,640727,57253,632107,201200,684829,297660,592145,784638,155240,324478,744631,900957,986166,266991,806897,10052,476653,477352,737855,258456,887703,935647,581424,744777,217583,437452,886119,757482,525675,920921,693874,391013,545923,697402,202452,363985,1016315,149751,831925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001887s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]