SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502858 LIMIT 1 [ RunTime:0.000745s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502858 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511910,506168,636239,896969,663623,320263,338529,558636,308245,629291,807643,477405,243400,698375,1007065,714754,423841,273597,263961,992065,916474,899082,800251,686619,374150,160778,1959,979547,155072,544121,965054,82612,328219,406461,614077,476801,316134,101883,65447,1023023,401512,198844,718568,975980,100869,803227,734056,240100,293583,320019,719539,936720,75179,955164,409461,542455,574418,823994,407321,417945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502858 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502858 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]