SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003657s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341726 LIMIT 1 [ RunTime:0.001985s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341726 [ RunTime:0.002864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348195,823446,74987,137012,960535,141174,1046069,154948,649805,715244,422739,723295,68101,344215,896902,390500,722402,997398,536993,674416,951698,39432,952249,865143,692693,275912,723589,388418,293126,709308,524206,420596,144542,1020708,961805,964660,678349,270263,534778,989328,819936,410289,392439,669988,769167,9932,291507,413942,491380,891166,336885,142814,426190,199332,1010182,37744,398799,1030744,687804,905049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000966s ]