SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308923 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308923 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424625,948282,594234,414875,483173,405371,600884,165109,483979,435661,805627,440560,938270,604699,233574,676630,653217,950485,175789,219915,213537,57747,722198,5444,1012,869770,1011206,258247,840385,956274,502159,345214,134898,607547,155177,523012,629679,203381,310705,917955,201640,23137,301371,796307,676761,655952,375028,717940,6129,891102,536971,767379,107661,233123,120422,895535,682916,509897,71627,1005929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]