SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020187 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020187 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139636,51062,790599,837785,250564,80935,598842,695395,935948,621242,167810,3618,76144,278256,831698,600483,686959,532849,987348,288808,236455,213589,288761,752045,538502,457100,399987,659122,756159,814917,1021687,481601,794440,545788,278583,691095,762904,527341,1044678,396607,680470,268006,160067,431520,978974,970123,36633,1009897,24792,95174,14672,253955,762786,472474,824002,173524,482704,643480,650684,857353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]