SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426098 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426098 [ RunTime:0.003080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189531,298075,514873,293632,281479,580295,851672,185283,471507,203921,703341,392646,368539,468889,10842,458988,264419,45602,42695,985589,442091,635364,695434,346881,688479,650691,986054,491440,912526,508593,881313,55231,262458,721458,124774,915913,1017434,82418,634263,268257,972244,244778,867684,121089,1019755,875569,517662,873376,714447,666744,599337,82182,482988,747962,561759,593684,957540,903969,220612,414004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]