SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580181 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580181 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030120,33205,783747,130510,976195,915108,60042,433158,636523,522954,26756,350978,645847,966687,187537,284474,444486,119336,559090,288404,1044463,924018,518083,178514,297406,677481,44406,649505,55776,240286,47778,411167,991004,214546,253621,920045,156323,27583,367574,267526,274039,78926,59405,557630,913680,4623,789291,736158,263768,813161,369386,199576,826360,95646,374482,118608,533678,228670,329546,477658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]