SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002465s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468852 LIMIT 1 [ RunTime:0.001112s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468852 [ RunTime:0.007302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107062,948303,737373,232845,104601,125145,607863,1038334,666162,569444,894821,428312,252530,152709,406682,953020,712282,920596,226739,651081,247997,353220,391144,671997,92127,714224,398300,77489,370726,251239,682385,1003377,135565,108290,695983,164014,680042,584014,939361,145344,179267,873861,218628,162092,395341,374748,862074,587379,38631,55620,35550,185159,679306,95747,665259,537853,214293,977282,924389,593497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468852 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468852 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005397s ]