SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506312 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506312 [ RunTime:0.002976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046479,848805,470112,8448,507521,490794,259489,970463,463368,633920,570062,346700,312101,600901,832891,690087,986849,742525,837970,845326,731753,1042253,82326,181592,903200,116743,533476,991874,799312,324539,324536,319612,993231,346675,495926,12673,528548,657883,828321,990466,563300,661551,877510,630682,381051,630504,623333,182,329695,811402,360987,562419,997992,1010400,921660,261048,852606,979464,996249,448301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]