SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291618 LIMIT 1 [ RunTime:0.000570s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291618 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002088,856605,701869,824810,89647,306239,250509,305255,222285,448730,338964,854727,473787,1026588,691130,894494,231197,617025,37046,92550,162308,586740,329885,593242,305127,745344,598126,518651,109007,1005098,312748,383091,653308,220813,722220,75117,828840,554117,136948,437387,1023167,197552,47732,595468,593008,209176,914371,205923,966399,804619,1009512,195427,172931,375478,494960,1024171,804183,958424,547189,319155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]