SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397610 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397610 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483033,837048,962818,634159,202119,376153,606050,636044,430781,599341,37036,138317,532078,302136,723240,135520,533505,433610,936306,130001,255341,632964,748048,194820,408506,954312,978261,178959,280772,809030,100670,177861,645369,579576,943882,519482,956718,631018,968416,442814,390223,618366,821089,466127,979598,64151,635636,762089,54229,70232,965880,920816,735969,350147,62521,7892,409952,721814,439140,781545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]