SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426743 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426743 [ RunTime:0.002185s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253019,1032629,432334,530953,319051,606774,436122,354322,953875,119678,312009,355968,398447,242381,228506,341212,152073,132261,327386,370308,265662,192291,549808,307501,466155,1014820,497558,676955,255089,142255,89520,847979,899479,939526,36888,181594,220407,657051,83553,972136,806984,304220,661398,116219,835117,621523,179806,320046,447688,583736,185354,739561,519461,789335,321513,56489,154291,568332,730307,888665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]