SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001715s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368099 LIMIT 1 [ RunTime:0.000531s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368099 [ RunTime:0.001309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419892,792033,222609,84615,711819,816379,200943,855738,711631,382118,725706,244697,629678,961619,484679,354480,702431,959470,137474,419812,205878,446800,255628,378855,124952,985265,298369,990550,114718,1030630,446035,85739,1011843,690936,163053,110987,515964,719871,948755,566166,771023,941172,257181,22355,966520,235486,192462,757331,781887,644772,694216,124413,987394,718708,233789,137585,903150,860752,1028234,583664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]