SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429390 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429390 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980135,454130,263218,1043489,291428,287094,643732,438994,925190,107253,59726,526235,752823,819100,841689,961730,371215,166949,281803,668911,642983,258143,913118,654664,481341,786403,262155,415357,944553,195761,779994,573095,210045,597818,168921,313660,835548,892640,85479,478390,870432,596466,857826,693956,986731,619421,42064,160749,667592,918217,74152,541824,894788,207862,779809,547371,816836,212604,953917,465370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]