SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002838s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531128 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531128 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337911,416065,260268,867623,1030068,136782,955304,959196,948918,154160,547137,682948,577304,716695,989526,496708,678465,261875,662883,1023541,79633,1044156,696372,52738,292398,723828,725898,505390,884963,565101,836370,306345,169117,366838,575497,316967,167230,195792,595893,101521,461552,629180,927003,779570,657641,856000,642509,920869,466040,641060,873305,190158,766248,426533,107146,887522,465818,227484,725401,635481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]