SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447313 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447313 [ RunTime:0.002210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1071,988282,577704,891773,57506,896939,229565,958400,908934,921336,1029490,743404,505068,234711,76487,712246,120712,363841,864226,1030864,690746,351940,285799,503608,336763,1043392,799806,634176,92311,540027,731013,96273,36510,880782,555457,764190,228517,742085,945477,193597,930026,572394,209336,538250,633178,452707,996899,660949,274746,227074,324404,563800,295223,191861,146200,54462,541483,383254,222417,584666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]