SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001840s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471612 LIMIT 1 [ RunTime:0.002078s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471612 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436330,494041,277600,161177,540916,794501,878191,1030931,393364,503304,943627,177393,1014308,736080,672142,222358,305969,151429,68416,395152,862209,714409,107891,1047629,57529,708480,878570,1032838,757776,101565,782678,821877,599838,930374,234980,355095,712242,985368,750263,558153,735480,223382,288301,477654,390822,819608,450496,702708,758703,516065,636996,6950,878492,158280,934027,295311,782523,686304,65057,406971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]