SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982813 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982813 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262148,758047,606953,138064,965552,507207,339657,454945,173634,629129,479173,1014274,483000,458321,692042,175317,355740,551146,298788,66246,173567,697353,178772,213118,215269,285490,80895,382661,24596,892019,1024389,830833,437402,163974,509716,562376,171233,306255,557276,312185,258018,819523,781675,221845,226728,343787,76357,399319,546805,321205,696213,368472,549129,565254,930891,708624,922497,99776,1029492,438231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]