SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263794 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263794 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369420,943911,399050,436352,30569,664205,723715,318245,909357,579726,365742,430227,984550,650747,970982,463602,711703,904742,822026,402790,285031,220568,779270,52952,126521,635260,1040131,481128,482680,113474,381524,145869,438835,938398,733982,861929,89560,243696,45500,681857,624608,449162,876450,170860,589838,589771,286352,674990,288617,162066,671075,470525,380416,883273,237740,150421,933650,158745,100332,1002540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001346s ]