SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425534 LIMIT 1 [ RunTime:0.001296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425534 [ RunTime:0.006638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556552,729793,188339,525509,640049,1047341,740023,139930,444383,171604,815218,258266,164731,57143,186601,489271,86203,30546,1047491,45787,234060,984474,762863,1001395,818193,446369,115357,6121,26844,197555,47167,123105,566051,518048,87598,415764,766497,823799,933151,777384,313080,346940,903263,635439,136654,681290,3603,834457,387744,363032,1042588,196854,230424,1011279,482733,389547,881116,115504,1017825,335676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004671s ]