SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014233 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014233 [ RunTime:0.001470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531019,201596,412560,213044,814710,262507,399758,921508,65005,670816,264988,323753,580824,103756,557468,602529,482719,498119,733933,369966,649161,601328,348143,725772,894381,584193,464659,1015521,863677,682282,28595,431333,945250,361175,283771,834489,598882,434259,890552,590972,985533,898507,779087,803510,843895,636572,227602,604596,389828,173265,652500,529985,628749,430990,255756,164952,516080,185387,490396,161211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014233 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014233 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]