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` = 179523 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 179523 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819992,1048060,167167,634133,663418,668877,1015131,353757,61127,567895,729156,568185,190707,99658,1014270,1032824,573335,208919,245241,744449,804372,527363,386964,614768,262189,429261,906964,182366,355499,652349,113875,1013496,825463,616710,176025,58023,17544,932520,236890,1011624,584807,1000252,422657,480454,553667,1022680,647480,220315,220652,25317,593706,139142,939506,925893,826139,47629,1044054,378041,293902,974848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 179523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 179523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]