SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515045 LIMIT 1 [ RunTime:0.001774s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515045 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31328,674012,779083,333160,898478,915242,828319,182903,724602,597428,47444,159464,403501,1039883,899051,626414,735446,1009458,900600,318656,322775,193213,446801,501038,365932,559107,933486,37538,554186,607726,788974,32380,110702,870287,814604,533877,372592,1034903,38541,26094,670349,564194,661671,810244,176275,1034614,785813,534762,889150,793677,500684,413448,141963,306305,858938,276838,735215,1019184,659040,803141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000969s ]