SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356946 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356946 [ RunTime:0.002208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486670,184134,876923,441862,771084,565738,375287,332817,171101,635194,255770,242888,43407,639904,633372,806149,774645,703485,568349,1041366,959214,745774,289038,494848,347122,968562,153774,871446,981312,283810,417414,986990,245908,88541,1030461,831501,411576,774489,883000,638295,548788,816705,156882,929204,554252,81521,23260,964129,714210,944553,120493,732046,117764,209955,293874,617368,757872,598674,354923,4927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]