SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 986801 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 986801 [ RunTime:0.001444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15900,718417,19773,909134,1035360,670143,223107,957610,753952,500232,159500,370758,787240,336682,382420,509532,68936,414621,109558,440634,520472,292165,495152,884188,639610,1004395,22535,754243,65714,254138,252571,80535,521373,160372,90540,959073,243449,350307,742336,1032619,671239,719090,937054,432084,561595,730748,1029228,325143,117268,900578,90700,135182,296956,557442,382614,296361,804234,227484,832821,71079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 986801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 986801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]