SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481417 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481417 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533032,802911,880676,242442,699132,777658,472306,407719,361309,399305,712240,868694,460872,345561,893594,418401,851548,1005584,432245,27783,333401,881347,199163,918147,428620,692248,155897,702407,156243,48668,1010036,941425,720686,403198,893602,980179,1033055,533394,494730,120590,665452,152376,903177,821706,135467,711599,200801,275173,272013,630620,930046,364510,259282,384317,990537,877407,712445,631150,905681,777310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]